UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5MAnBsEgh1kMAwPGZJ89li+SHLO4phSAx7LFoul7VKo='
WHERE
key_id = 'f710e4a8a253811b5ceb4c352181ceb97ff6c56c4a3b1f997baf4984945241f0'
AND (
token = '5MAnBsEgh1kMAwPGZJ89li+SHLO4phSAx7LFoul7VKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)