UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XJ+p0rJCi3UyMNWUQV8lGRZbyvIkfZrFtso3mKkjSj8='
WHERE
key_id = '9ae7f0e74398dfb3ac6cd59fed561bd2f249429a8c4a90494e65cf629aab51d8'
AND (
token = 'XJ+p0rJCi3UyMNWUQV8lGRZbyvIkfZrFtso3mKkjSj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)