UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BU4SjBkvn5z94UamoofCT7d71jOmlEVAg61Vq9LbcXU='
WHERE
key_id = 'afe63cbeabbd925d4e9358a68ebdc0f9108a9f82ae0bb46f3a72db5835210307'
AND (
token = 'BU4SjBkvn5z94UamoofCT7d71jOmlEVAg61Vq9LbcXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)