UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNLSiOOeB97R0eDB1knfmiPEhta93+7an4AxrevuT08='
WHERE
key_id = 'e1747c76b7c965f55d222e2c19b4b64065975cde77e6e3ccb5ce91a4584b82a5'
AND (
token = 'GNLSiOOeB97R0eDB1knfmiPEhta93+7an4AxrevuT08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)