UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPXobqJYeOn8JvZtiIkaoyKDdV167LlgUuWbmN7uc7A='
WHERE
key_id = '1026a11b80f58d302f24ad6dde97974b8bd24521be98db1c2282af2a20540591'
AND (
token = 'KPXobqJYeOn8JvZtiIkaoyKDdV167LlgUuWbmN7uc7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)