UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lPzF7rmRaVmgYKrZPNfNenQ+y5zU1MnX7yDSEP/MgHA='
WHERE
key_id = 'b49025a6d394dfd7b10ef3835caea26b78b71564da1b55a00fa35a6bdae7e8ca'
AND (
token = 'lPzF7rmRaVmgYKrZPNfNenQ+y5zU1MnX7yDSEP/MgHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)