UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DUpbqYtDnU0JOZxK4nkOL9euCfTOjxDj6SybwHN37nY='
WHERE
key_id = '592b83a4f53ec6e7b0d63b2ebf42eb234f0f3d98401548bb3a934c89ece58cf6'
AND (
token = 'DUpbqYtDnU0JOZxK4nkOL9euCfTOjxDj6SybwHN37nY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)