UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QDgU0pq0J6mo1RWXDUhEK8SFpITxuFQnBDWcoVSRraE='
WHERE
key_id = 'be3ad58f2394ee43f52befecc323cac45389a7987e8ab258b8fad7405f7bba67'
AND (
token = 'QDgU0pq0J6mo1RWXDUhEK8SFpITxuFQnBDWcoVSRraE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)