UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2D1uIRG8ehc+TFCmZCoDhpvhQTJpreAzubY41DIElC8='
WHERE
key_id = '49efb2b16bd80fd587287cd57c539f44557c40ad08834f6655c8d6afef2f5bc7'
AND (
token = '2D1uIRG8ehc+TFCmZCoDhpvhQTJpreAzubY41DIElC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)