UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhbjHaIKrTD1l69NK8oMz3mF1jhJvdhLsivx6WCWwbM='
WHERE
key_id = '9edc0ee1e6fd7273113372291823b4e310b6b2a7d518571ac4f2a222c7459b13'
AND (
token = 'XhbjHaIKrTD1l69NK8oMz3mF1jhJvdhLsivx6WCWwbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)