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