UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kpFcmKpCcgOeXi6DFCYDKbijqWUH9xV/0t3lI4B5tlU='
WHERE
key_id = 'c9a8fcc317277653a4b74d7e314b77151123d949eb605fa96cd952149a66f3b9'
AND (
token = 'kpFcmKpCcgOeXi6DFCYDKbijqWUH9xV/0t3lI4B5tlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)