UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PutnA4z8wgsi7sMb3DJtb8g6ItP8kuja/yo1kzK32Sw='
WHERE
key_id = 'c6de6a096802123b84430ce4dc7a94512111be02f88ef2b7ec13cd5b9f7821b7'
AND (
token = 'PutnA4z8wgsi7sMb3DJtb8g6ItP8kuja/yo1kzK32Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)