UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vs2WUzciO/voq5YIr+HJpm8o7agm7Xi6MgPZsbQPvLY='
WHERE
key_id = '78e5d04a69c369079e1c7d6cac3986950faa998616fd7fe42f532335478d5021'
AND (
token = 'Vs2WUzciO/voq5YIr+HJpm8o7agm7Xi6MgPZsbQPvLY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)