UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/CvAzUFriPctn67VWivaJGpqza4s30OqPtPFCc5FKU='
WHERE
key_id = 'c31691561947cfeb57ae5f6d0a90d6906f542e66595ded8661f7f3f7643cab61'
AND (
token = 'U/CvAzUFriPctn67VWivaJGpqza4s30OqPtPFCc5FKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)