UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7W4WCy2+u3bFbVn8lfC8kyoNARyBWHJhjbLjOndPtMM='
WHERE
key_id = 'c3eeaf5706a5a6ebb22f42aa296e5f11e5c700aa226b0b7f53be4e488b0b344a'
AND (
token = '7W4WCy2+u3bFbVn8lfC8kyoNARyBWHJhjbLjOndPtMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)