UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ixlX2Dn3ahoisNA9J+hD4Xehw7wrrKX2nB0S8hHHiQ='
WHERE
key_id = 'fcd0f84a542784139924c073fc648e74d68a0123a71287fad230a82eaf7ce98e'
AND (
token = '8ixlX2Dn3ahoisNA9J+hD4Xehw7wrrKX2nB0S8hHHiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)