UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmgfCbHzA7hlg1QQznt/n5cBXTI93Uox6itzRJJ62YA='
WHERE
key_id = 'b524dfde734e769260c245db2308cbbced141110aa7ba9aac8bb78db55938f0f'
AND (
token = 'pmgfCbHzA7hlg1QQznt/n5cBXTI93Uox6itzRJJ62YA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)