UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '64I/NpB3viIWcnkU87FxgKDe5jPNZzjw0WIXAW9bTdw='
WHERE
key_id = '04e5e2f5b131af89ee40a45da28de4efb5869a165b62534c73125becb4c21feb'
AND (
token = '64I/NpB3viIWcnkU87FxgKDe5jPNZzjw0WIXAW9bTdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)