UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZGIJZd5Q8vSWlT4LAd7MVa4PKLbHEMmOZw1fz0URnw='
WHERE
key_id = '1220cd6d3ebb00ffedfdad0b849cfef61239993eaf4ec29bf812d64191ae212b'
AND (
token = '7ZGIJZd5Q8vSWlT4LAd7MVa4PKLbHEMmOZw1fz0URnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)