UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZBOxPlqAJXR+dHpaJFZbfu0KlmTAvkU0ZVDBkOOW7o='
WHERE
key_id = 'df30ad0acc5780e00d59fb219044e42acce4634f18837f756f57d194af13f199'
AND (
token = 'nZBOxPlqAJXR+dHpaJFZbfu0KlmTAvkU0ZVDBkOOW7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)