UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SxWgubj4U30MT722puXEgxgCgcNXpIK0WOFeupLSyB8='
WHERE
key_id = '77f3aa867073d78c81628b89820772e3a9c3916ad8dc6ea96e1c6bb8962ad661'
AND (
token = 'SxWgubj4U30MT722puXEgxgCgcNXpIK0WOFeupLSyB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)