UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCpCyvgl9lREqS3yh3ICvuK7Jgv3z2YMsjCYry1Vbfk='
WHERE
key_id = '6a5949a86d411bbd1cdea61747cdc869887e251191d545ab25001a8f610656a6'
AND (
token = 'QCpCyvgl9lREqS3yh3ICvuK7Jgv3z2YMsjCYry1Vbfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)