UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnfHsjZU9/DKoq1SzlAMS0O4XX7kVGm2HJDu5kNxVx8='
WHERE
key_id = 'c4c0b3abbcc381efcf89df8e2b376000df041ba060fd9d4b78fc46b61dec41e2'
AND (
token = 'vnfHsjZU9/DKoq1SzlAMS0O4XX7kVGm2HJDu5kNxVx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)