UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GDu7U810pkUtvuqhuQjF8mPS+mnB87JHpet5YBzMm0='
WHERE
key_id = 'd63920f74678f575c507c2a77a85a92bf724febdea2b58171e13c5e77a8cc771'
AND (
token = '8GDu7U810pkUtvuqhuQjF8mPS+mnB87JHpet5YBzMm0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)