UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3yH99tSugNlPrb16ww43VNMrKy9cMSx7ary9Ia0UMmM='
WHERE
key_id = '27ae8360cf30b1b086f6eb096e973cf2a8ae0f7ad6e6a7cdc093f722c115dcc7'
AND (
token = '3yH99tSugNlPrb16ww43VNMrKy9cMSx7ary9Ia0UMmM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)