UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnGhihY0kRhf843rsAAor1yrjXFxOPFX4ZCfXUs3Oxw='
WHERE
key_id = '424b1b048f0d9ea5fbb7c188929691346f54968e9f73a8c112d6dcf9a6f648c0'
AND (
token = 'gnGhihY0kRhf843rsAAor1yrjXFxOPFX4ZCfXUs3Oxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)