UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DH8iXW8uis+u3cfpFtW8QORMFksHKjmVaDUX+5UPhHA='
WHERE
key_id = 'f050d6f2fa901095f247f38bf1dbebf9ef152885ba5580a9c6645dcff5a3e366'
AND (
token = 'DH8iXW8uis+u3cfpFtW8QORMFksHKjmVaDUX+5UPhHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)