UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b4cHRp8z+7fu9Yf2hSAAVj2ZXisg9M0NuMBLHyUbQYc='
WHERE
key_id = 'd7a4c95e27a96abee5e98dc17c8938a8b6e4e62a8defc38857f076cc7d929af6'
AND (
token = 'b4cHRp8z+7fu9Yf2hSAAVj2ZXisg9M0NuMBLHyUbQYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)