UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Q7vcOzcfUztjg5JWJiQ7nzQbvf8U+zaSPjp1IcEPR4='
WHERE
key_id = '7b2c9d0051b0f092cc484f472210b58764f17f48c0ad242ae68288a701329a5c'
AND (
token = '0Q7vcOzcfUztjg5JWJiQ7nzQbvf8U+zaSPjp1IcEPR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)