UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zf8NyzIYp+Z1tW8Z4eCb+uJ1dlWsZPAOumC7rqUfZf8='
WHERE
key_id = '5a31ff1c916a9f3697915b5663a4128a587ba0492773682ba15d79e77013ce57'
AND (
token = 'Zf8NyzIYp+Z1tW8Z4eCb+uJ1dlWsZPAOumC7rqUfZf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)