UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kqpyEFZl50cLvkoWoCmtgEnklSXkVXOdun/PP6x7LlU='
WHERE
key_id = 'a548b54a6f15e7562157f36f863c9e374e570170c23b04694a113788171d846c'
AND (
token = 'kqpyEFZl50cLvkoWoCmtgEnklSXkVXOdun/PP6x7LlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)