UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XssMgYHC2bF+O3qSUUlWT9TFVv0fnV61glu+eMs5et0='
WHERE
key_id = 'f457cde092435a9d3ccfcbbfa4e096d4a18673b9df708e6ffe6290f7cb40eb93'
AND (
token = 'XssMgYHC2bF+O3qSUUlWT9TFVv0fnV61glu+eMs5et0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)