UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK1ZmPkiy0cSXjUsErjEZy0ySwvoBrXLglkNAqdy/UI='
WHERE
key_id = '7a43d77309c68467e978a978da096115f5cc1210734d515dc5c37626c19206f4'
AND (
token = 'zK1ZmPkiy0cSXjUsErjEZy0ySwvoBrXLglkNAqdy/UI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)