UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+J+zw6gv26w6e+TtXk7ZdSS7DCYEUiaCHB18L/er0w='
WHERE
key_id = '2e67edfd7382cd3f396577f88d3fc5465e407cf65d7f2e6f75aed3b725b85bfb'
AND (
token = 'z+J+zw6gv26w6e+TtXk7ZdSS7DCYEUiaCHB18L/er0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)