UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r4xAsIef2W6ykipgtSqX/V9M2zI60JRISkrOeI5Vvgw='
WHERE
key_id = 'fcf69b30b266f1b44ffb20d477f79a4333c7e523f56527c58fe4e72668612a4d'
AND (
token = 'r4xAsIef2W6ykipgtSqX/V9M2zI60JRISkrOeI5Vvgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)